Temporal Data in Relational Database Systems: A Comparison
نویسنده
چکیده
Several database systems have implemented temporal data support, partly according to the model specified in the last SQL standard and partly according to other, older temporal models. In this article we use the most important temporal concepts to investigate their implementations in enterprise database systems. Also, we discuss strengths and weaknesses of these implementations and give suggestions for future extensions.
منابع مشابه
Implementing Temporal Databases in Object-Oriented Systems
We present a temporal object data model, query language and system that support temporal database applications. We then show how equivalent temporal constructs and operations could be provided in existing object-oriented database management systems (OODBMS) and describe how we did this in the O2 system. A comparison of the two resulting systems highlights the current limitations to the notions ...
متن کاملA Logical Temporal Relational Data Model
Time is one of the most difficult aspects to handle in real world applications such as database systems. Relational database management systems proposed by Codd offer very little built-in query language support for temporal data management. The model itself incorporates neither the concept of time nor any theory of temporal semantics. Many temporal extensions of the relational model have been p...
متن کاملEfficiently Processing Queries on Interval-and-Value Tuples in Relational Databases
With the increasing occurrence of temporal and spatial data in present-day database applications, the interval data type is adopted by more and more database systems. For an efficient support of queries that contain selections on interval attributes as well as simple-valued attributes (e. g. numbers, strings) at the same time, special index structures are required supporting both types of predi...
متن کاملImplementing Temporal Databases in Object-oriented Systems a Timecenter Technical Report Title Implementing Temporal Databases in Object-oriented Systems Author(s) Individual Participants
We present a temporal object data model, query language and system that support temporal database applications. We then show how equivalent temporal constructs and operations could be provided in existing object-oriented database management systems (OODBMS) and describe how we did this in the O2 system. A comparison of the two resulting systems highlights the current limitations to the notions ...
متن کاملDesign Issues in Transaction-Time Temporal Object Database Systems
Object database systems (ODBs) are an attractive alternative to relational database systems, especially in application areas where the modeling power or performance of relational database systems is insufficient. These applications typically maintain large amounts of data. Frequently, some of the data is temporal data. For the temporal data, the whole history of the individual objects is kept, ...
متن کامل